Max_User_IDs are being reused in certain circumstances in SAS Merchandise Planning, allowing for favorites and assignments to carry over incorrectly.

The steps to recreate this problem are as follows:

1. Create a User (User A).
2. Assign some templates to that user.
3. Delete User A from within the application.
4. Immediately create another user (User B).
5. Log on to the application as User B.
6. Go to Template Manager.
7. Sort on Assigned templates.

The templates that were assigned to User A display for User B. There should be no templates assigned to the new user. This example featured templates, but this issue also occurs for other objects within SAS Merchandise Planning.

This issues only happens if User A (in this scenario) is sequentially the last max_user_id number. If this is not the case, then the problem will not occur.

The workaround is to create the new user (User B) before deleting the old user (User A).

Operating System and Release Information